﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO dbo.Unit VALUES('oz'), ('gallon'), ('set'), ('color'), ('gram'), ('kit'), ('none')

INSERT INTO dbo.UpcNote VALUES('NW', 'New package'), ('OP', 'Old package'), ('NE', 'Non English')

INSERT INTO dbo.Configuration 
VALUES
(
	'CompanyInfo', 
	'Keiko'
)

INSERT INTO dbo.Category 
VALUES 
	('Shampoo'), 
	('Conditioner'), 
	('Styling'), 
	('Accessories'), 
	('Skin Care'), 
	('Eye Care'), 
	('Lip Care')

--IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'lpprogram')
--CREATE LOGIN lpprogram WITH PASSWORD = 'lp123', DEFAULT_DATABASE = Warehouse, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
--GO
--USE Warehouse
--GO
--IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'lpprogram')
--BEGIN
--	CREATE USER lpprogram FOR LOGIN lpprogram WITH DEFAULT_SCHEMA = dbo
--	EXEC sp_addrolemember N'db_owner', N'lpprogram'
--END
GO

